<report xmlns="http://developer.cognos.com/schemas/report/12.0/" expressionLocale="en-us" useStyleVersion="10"><!--RSU-SPC-0093 The report specification was upgraded from "http://developer.cognos.com/schemas/report/11.0/" to "http://developer.cognos.com/schemas/report/12.0/" at 2016-12-26. 15:6:36--><!--RSU-SPC-0093 The report specification was upgraded from &amp;amp;amp;amp;amp;quot;http://developer.cognos.com/schemas/report/8.0/&amp;amp;amp;amp;amp;quot; to &amp;amp;amp;amp;amp;quot;http://developer.cognos.com/schemas/report/11.0/&amp;amp;amp;amp;amp;quot; at 2014-9-23. 10:26:38-->
				<modelPath>/content/folder[@name='Packages']/package[@name='Switch Performance']/model[@name='model']</modelPath>
				<drillBehavior modelBasedDrillThru="true"/>
				<queries>
					<query name="Report">
						<source>
							
						<sqlQuery dataSource="dwh_performance" name="SQL1">
			<sqlText>select 
dwh_performance.switch_dimension.datacenter as "Data Center",
dwh_performance.switch_dimension.name as "Switch Name",
dwh_performance.port_dimension.name as "Port Name",
dwh_performance.port_dimension.speed as "Port Speed",
dwh_performance.port_dimension.type as "Port Type",
dwh_performance.date_dimension.fulldate as "Full Date",
dwh_performance.time_dimension.hourdatetime as "Time",

dwh_performance.switch_performance_for_port_hourly_fact.isl as "Is ISL Port",
sum(dwh_performance.switch_performance_for_port_hourly_fact.rxTraffic) as "Rx Value MB",
sum(dwh_performance.switch_performance_for_port_hourly_fact.txTraffic) as "Tx Value MB",
sum(dwh_performance.switch_performance_for_port_hourly_fact.bbcrediterrorcount) as "BB Credit Error Count",
sum(dwh_performance.switch_performance_for_port_hourly_fact.synclosscount) as "Sync Loss Count",
sum(dwh_performance.switch_performance_for_port_hourly_fact.signallosscount) as "Signal Loss Count",
max(dwh_performance.switch_performance_for_port_hourly_fact.errorrateflag) as "Error Rate Flag",
max(dwh_performance.switch_performance_for_port_hourly_fact.crcerrorrateflag) as "CRC Error Rate Flag",
sum(dwh_performance.switch_performance_for_port_hourly_fact.class3discardcount) as "Class 3 Discard Count"

from dwh_performance.switch_dimension
JOIN
dwh_performance.switch_performance_for_port_hourly_fact
ON dwh_performance.switch_performance_for_port_hourly_fact.switchtk=dwh_performance.switch_dimension.tk
JOIN
dwh_performance.port_dimension
ON dwh_performance.switch_performance_for_port_hourly_fact.porttk=dwh_performance.port_dimension.tk
JOIN
dwh_performance.time_dimension
ON dwh_performance.switch_performance_for_port_hourly_fact.timetk=dwh_performance.time_dimension.tk
JOIN
dwh_performance.date_dimension
ON dwh_performance.switch_performance_for_port_hourly_fact.datetk=dwh_performance.date_dimension.tk

group by dwh_performance.switch_dimension.name, dwh_performance.port_dimension.name, dwh_performance.time_dimension.tk
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Data Center"/><mdProjectedItem name="Switch Name"/><mdProjectedItem name="Port Name"/><mdProjectedItem name="Port Speed"/><mdProjectedItem name="Port Type"/><mdProjectedItem name="Full Date"/><mdProjectedItem name="Time"/><mdProjectedItem name="Is ISL Port"/><mdProjectedItem name="Rx Value MB"/><mdProjectedItem name="Tx Value MB"/><mdProjectedItem name="BB Credit Error Count"/><mdProjectedItem name="Sync Loss Count"/><mdProjectedItem name="Signal Loss Count"/><mdProjectedItem name="Error Rate Flag"/><mdProjectedItem name="CRC Error Rate Flag"/><mdProjectedItem name="Class 3 Discard Count"/></mdProjectedItems></sqlQuery></source>
						<selection><dataItem name="Data Center"><expression>[SQL1].[Data Center]</expression></dataItem><dataItem name="Switch Name"><expression>[SQL1].[Switch Name]</expression></dataItem><dataItem name="Port Name"><expression>[SQL1].[Port Name]</expression></dataItem><dataItem name="Port Speed"><expression>[SQL1].[Port Speed]</expression></dataItem><dataItem name="Port Type"><expression>[SQL1].[Port Type]</expression></dataItem><dataItem name="Full Date"><expression>[SQL1].[Full Date]</expression></dataItem><dataItem name="Is ISL Port"><expression>if([SQL1].[Is ISL Port]=1) then ('ISL Port') else (null)</expression></dataItem><dataItem aggregate="average" name="Rx Value MB"><expression>[SQL1].[Rx Value MB]</expression></dataItem><dataItem aggregate="average" name="Tx Value MB"><expression>[SQL1].[Tx Value MB]</expression></dataItem><dataItem aggregate="total" name="BB Credit Error Count"><expression>[SQL1].[BB Credit Error Count]</expression></dataItem><dataItem aggregate="total" name="Sync Loss Count"><expression>[SQL1].[Sync Loss Count]</expression></dataItem><dataItem aggregate="total" name="Signal Loss Count"><expression>[SQL1].[Signal Loss Count]</expression></dataItem><dataItem aggregate="total" name="Error Rate Flag"><expression>[SQL1].[Error Rate Flag]</expression></dataItem><dataItem aggregate="total" name="CRC Error Rate Flag"><expression>[SQL1].[CRC Error Rate Flag]</expression></dataItem><dataItem aggregate="total" name="Class 3 Discard Count"><expression>[SQL1].[Class 3 Discard Count]</expression></dataItem><dataItemListSummary aggregateMethod="average" name="Average(Rx Value MB)" refDataItem="Rx Value MB"/><dataItemListSummary aggregateMethod="average" name="Average(Tx Value MB)" refDataItem="Tx Value MB"/><dataItemListSummary aggregateMethod="average" name="Average(BB Credit Error Count)" refDataItem="BB Credit Error Count"/><dataItemListSummary aggregateMethod="average" name="Average(Sync Loss Count)" refDataItem="Sync Loss Count"/><dataItemListSummary aggregateMethod="average" name="Average(Signal Loss Count)" refDataItem="Signal Loss Count"/><dataItemListSummary aggregateMethod="average" name="Average(Error Rate Flag)" refDataItem="Error Rate Flag"/><dataItemListSummary aggregateMethod="average" name="Average(CRC Error Rate Flag)" refDataItem="CRC Error Rate Flag"/><dataItemListSummary aggregateMethod="average" name="Average(Class 3 Discard Count)" refDataItem="Class 3 Discard Count"/></selection>
					<detailFilters><detailFilter use="optional"><filterExpression>[Full Date] between ?sFrom? and ?sTo?</filterExpression></detailFilter><detailFilter use="optional"><filterExpression>[Switch Name] in ?sSwitch?</filterExpression></detailFilter><detailFilter><filterExpression>[Rx Value MB]&gt;0</filterExpression></detailFilter></detailFilters></query>
				<query name="Chart">
						<source>
							
						<sqlQuery dataSource="dwh_performance" name="SQL1">
			<sqlText>select 
dwh_performance.switch_dimension.datacenter as "Data Center",
dwh_performance.switch_dimension.name as "Switch Name",
dwh_performance.port_dimension.name as "Port Name",
dwh_performance.port_dimension.speed as "Port Speed",
dwh_performance.port_dimension.type as "Port Type",
dwh_performance.date_dimension.fulldate as "Full Date",
dwh_performance.time_dimension.hourdatetime as "Time",

dwh_performance.switch_performance_for_port_hourly_fact.isl as "Is ISL Port",
sum(dwh_performance.switch_performance_for_port_hourly_fact.rxTraffic) as "Rx Value MB",
sum(dwh_performance.switch_performance_for_port_hourly_fact.txTraffic) as "Tx Value MB",
sum(dwh_performance.switch_performance_for_port_hourly_fact.bbcrediterrorcount) as "BB Credit Error Count",
sum(dwh_performance.switch_performance_for_port_hourly_fact.synclosscount) as "Sync Loss Count",
sum(dwh_performance.switch_performance_for_port_hourly_fact.signallosscount) as "Signal Loss Count",
max(dwh_performance.switch_performance_for_port_hourly_fact.errorrateflag) as "Error Rate Flag",
max(dwh_performance.switch_performance_for_port_hourly_fact.crcerrorrateflag) as "CRC Error Rate Flag",
sum(dwh_performance.switch_performance_for_port_hourly_fact.class3discardcount) as "Class 3 Discard Count"

from dwh_performance.switch_dimension
JOIN
dwh_performance.switch_performance_for_port_hourly_fact
ON dwh_performance.switch_performance_for_port_hourly_fact.switchtk=dwh_performance.switch_dimension.tk
JOIN
dwh_performance.port_dimension
ON dwh_performance.switch_performance_for_port_hourly_fact.porttk=dwh_performance.port_dimension.tk
JOIN
dwh_performance.time_dimension
ON dwh_performance.switch_performance_for_port_hourly_fact.timetk=dwh_performance.time_dimension.tk
JOIN
dwh_performance.date_dimension
ON dwh_performance.switch_performance_for_port_hourly_fact.datetk=dwh_performance.date_dimension.tk

group by dwh_performance.switch_dimension.name, dwh_performance.port_dimension.name, dwh_performance.time_dimension.tk
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Data Center"/><mdProjectedItem name="Switch Name"/><mdProjectedItem name="Port Name"/><mdProjectedItem name="Port Speed"/><mdProjectedItem name="Port Type"/><mdProjectedItem name="Full Date"/><mdProjectedItem name="Time"/><mdProjectedItem name="Is ISL Port"/><mdProjectedItem name="Rx Value MB"/><mdProjectedItem name="Tx Value MB"/><mdProjectedItem name="BB Credit Error Count"/><mdProjectedItem name="Sync Loss Count"/><mdProjectedItem name="Signal Loss Count"/><mdProjectedItem name="Error Rate Flag"/><mdProjectedItem name="CRC Error Rate Flag"/><mdProjectedItem name="Class 3 Discard Count"/></mdProjectedItems></sqlQuery></source>
						<selection><dataItem name="Data Center"><expression>[SQL1].[Data Center]</expression></dataItem><dataItem name="Switch Name"><expression>[SQL1].[Switch Name]</expression></dataItem><dataItem name="Port Name"><expression>[SQL1].[Port Name]</expression></dataItem><dataItem name="Port Speed"><expression>[SQL1].[Port Speed]</expression></dataItem><dataItem name="Port Type"><expression>[SQL1].[Port Type]</expression></dataItem><dataItem name="Full Date"><expression>[SQL1].[Full Date]</expression></dataItem><dataItem name="Is ISL Port"><expression>if([SQL1].[Is ISL Port]=1) then ('ISL Port') else (null)</expression></dataItem><dataItem aggregate="average" name="Rx Value MB"><expression>[SQL1].[Rx Value MB]</expression></dataItem><dataItem aggregate="average" name="Tx Value MB"><expression>[SQL1].[Tx Value MB]</expression></dataItem><dataItem aggregate="total" name="BB Credit Error Count"><expression>[SQL1].[BB Credit Error Count]</expression></dataItem><dataItem aggregate="total" name="Sync Loss Count"><expression>[SQL1].[Sync Loss Count]</expression></dataItem><dataItem aggregate="total" name="Signal Loss Count"><expression>[SQL1].[Signal Loss Count]</expression></dataItem><dataItem aggregate="total" name="Error Rate Flag"><expression>[SQL1].[Error Rate Flag]</expression></dataItem><dataItem aggregate="total" name="CRC Error Rate Flag"><expression>[SQL1].[CRC Error Rate Flag]</expression></dataItem><dataItem aggregate="total" name="Class 3 Discard Count"><expression>[SQL1].[Class 3 Discard Count]</expression></dataItem><dataItemListSummary aggregateMethod="average" name="Average(Rx Value MB)" refDataItem="Rx Value MB"/><dataItemListSummary aggregateMethod="average" name="Average(Tx Value MB)" refDataItem="Tx Value MB"/><dataItemListSummary aggregateMethod="average" name="Average(BB Credit Error Count)" refDataItem="BB Credit Error Count"/><dataItemListSummary aggregateMethod="average" name="Average(Sync Loss Count)" refDataItem="Sync Loss Count"/><dataItemListSummary aggregateMethod="average" name="Average(Signal Loss Count)" refDataItem="Signal Loss Count"/><dataItemListSummary aggregateMethod="average" name="Average(Error Rate Flag)" refDataItem="Error Rate Flag"/><dataItemListSummary aggregateMethod="average" name="Average(CRC Error Rate Flag)" refDataItem="CRC Error Rate Flag"/><dataItemListSummary aggregateMethod="average" name="Average(Class 3 Discard Count)" refDataItem="Class 3 Discard Count"/><dataItem name="rank"><expression>rank([Total Throughput MB] for [Port Name] )</expression></dataItem><dataItem aggregate="average" name="Total Throughput MB"><expression>[Rx Value MB]+[Tx Value MB]</expression></dataItem></selection>
					<detailFilters><detailFilter use="optional"><filterExpression>[Full Date] between ?sFrom? and ?sTo?</filterExpression></detailFilter><detailFilter use="optional"><filterExpression>[Switch Name] in ?sSwitch?</filterExpression></detailFilter><detailFilter postAutoAggregation="true"><filterExpression>[rank]&lt;11</filterExpression></detailFilter></detailFilters></query><query name="High BB Credit Count">
						<source>
							
						<sqlQuery dataSource="dwh_performance" name="SQL1">
			<sqlText>select 
dwh_performance.switch_dimension.datacenter as "Data Center",
dwh_performance.switch_dimension.name as "Switch Name",
dwh_performance.port_dimension.name as "Port Name",
dwh_performance.port_dimension.speed as "Port Speed",
dwh_performance.port_dimension.type as "Port Type",
dwh_performance.date_dimension.fulldate as "Full Date",
dwh_performance.time_dimension.hourdatetime as "Time",

dwh_performance.switch_performance_for_port_hourly_fact.isl as "Is ISL Port",
sum(dwh_performance.switch_performance_for_port_hourly_fact.rxTraffic) as "Rx Value MB",
sum(dwh_performance.switch_performance_for_port_hourly_fact.txTraffic) as "Tx Value MB",
sum(dwh_performance.switch_performance_for_port_hourly_fact.bbcrediterrorcount) as "BB Credit Error Count",
sum(dwh_performance.switch_performance_for_port_hourly_fact.synclosscount) as "Sync Loss Count",
sum(dwh_performance.switch_performance_for_port_hourly_fact.signallosscount) as "Signal Loss Count",
max(dwh_performance.switch_performance_for_port_hourly_fact.errorrateflag) as "Error Rate Flag",
max(dwh_performance.switch_performance_for_port_hourly_fact.crcerrorrateflag) as "CRC Error Rate Flag",
sum(dwh_performance.switch_performance_for_port_hourly_fact.class3discardcount) as "Class 3 Discard Count"

from dwh_performance.switch_dimension
JOIN
dwh_performance.switch_performance_for_port_hourly_fact
ON dwh_performance.switch_performance_for_port_hourly_fact.switchtk=dwh_performance.switch_dimension.tk
JOIN
dwh_performance.port_dimension
ON dwh_performance.switch_performance_for_port_hourly_fact.porttk=dwh_performance.port_dimension.tk
JOIN
dwh_performance.time_dimension
ON dwh_performance.switch_performance_for_port_hourly_fact.timetk=dwh_performance.time_dimension.tk
JOIN
dwh_performance.date_dimension
ON dwh_performance.switch_performance_for_port_hourly_fact.datetk=dwh_performance.date_dimension.tk

group by dwh_performance.switch_dimension.name, dwh_performance.port_dimension.name, dwh_performance.time_dimension.tk
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Data Center"/><mdProjectedItem name="Switch Name"/><mdProjectedItem name="Port Name"/><mdProjectedItem name="Port Speed"/><mdProjectedItem name="Port Type"/><mdProjectedItem name="Full Date"/><mdProjectedItem name="Time"/><mdProjectedItem name="Is ISL Port"/><mdProjectedItem name="Rx Value MB"/><mdProjectedItem name="Tx Value MB"/><mdProjectedItem name="BB Credit Error Count"/><mdProjectedItem name="Sync Loss Count"/><mdProjectedItem name="Signal Loss Count"/><mdProjectedItem name="Error Rate Flag"/><mdProjectedItem name="CRC Error Rate Flag"/><mdProjectedItem name="Class 3 Discard Count"/></mdProjectedItems></sqlQuery></source>
						<selection><dataItem name="Data Center"><expression>[SQL1].[Data Center]</expression></dataItem><dataItem name="Switch Name"><expression>[SQL1].[Switch Name]</expression></dataItem><dataItem name="Port Name"><expression>[SQL1].[Port Name]</expression></dataItem><dataItem name="Port Speed"><expression>[SQL1].[Port Speed]</expression></dataItem><dataItem name="Port Type"><expression>[SQL1].[Port Type]</expression></dataItem><dataItem name="Full Date"><expression>[SQL1].[Full Date]</expression></dataItem><dataItem name="Is ISL Port"><expression>if([SQL1].[Is ISL Port]=1) then ('ISL Port') else (null)</expression></dataItem><dataItem aggregate="average" name="Rx Value MB"><expression>[SQL1].[Rx Value MB]</expression></dataItem><dataItem aggregate="average" name="Tx Value MB"><expression>[SQL1].[Tx Value MB]</expression></dataItem><dataItem aggregate="total" name="BB Credit Error Count"><expression>[SQL1].[BB Credit Error Count]</expression></dataItem><dataItem aggregate="total" name="Sync Loss Count"><expression>[SQL1].[Sync Loss Count]</expression></dataItem><dataItem aggregate="total" name="Signal Loss Count"><expression>[SQL1].[Signal Loss Count]</expression></dataItem><dataItem aggregate="total" name="Error Rate Flag"><expression>[SQL1].[Error Rate Flag]</expression></dataItem><dataItem aggregate="total" name="CRC Error Rate Flag"><expression>[SQL1].[CRC Error Rate Flag]</expression></dataItem><dataItem aggregate="total" name="Class 3 Discard Count"><expression>[SQL1].[Class 3 Discard Count]</expression></dataItem><dataItemListSummary aggregateMethod="average" name="Average(Rx Value MB)" refDataItem="Rx Value MB"/><dataItemListSummary aggregateMethod="average" name="Average(Tx Value MB)" refDataItem="Tx Value MB"/><dataItemListSummary aggregateMethod="average" name="Average(BB Credit Error Count)" refDataItem="BB Credit Error Count"/><dataItemListSummary aggregateMethod="average" name="Average(Sync Loss Count)" refDataItem="Sync Loss Count"/><dataItemListSummary aggregateMethod="average" name="Average(Signal Loss Count)" refDataItem="Signal Loss Count"/><dataItemListSummary aggregateMethod="average" name="Average(Error Rate Flag)" refDataItem="Error Rate Flag"/><dataItemListSummary aggregateMethod="average" name="Average(CRC Error Rate Flag)" refDataItem="CRC Error Rate Flag"/><dataItemListSummary aggregateMethod="average" name="Average(Class 3 Discard Count)" refDataItem="Class 3 Discard Count"/><dataItem name="rank"><expression>rank([Total Throughput MB] for [Port Name] )</expression></dataItem><dataItem aggregate="average" name="Total Throughput MB"><expression>[Rx Value MB]+[Tx Value MB]</expression></dataItem></selection>
					<detailFilters><detailFilter use="optional"><filterExpression>[Full Date] between ?sFrom? and ?sTo?</filterExpression></detailFilter><detailFilter use="optional"><filterExpression>[Switch Name] in ?sSwitch?</filterExpression></detailFilter><detailFilter><filterExpression>[BB Credit Error Count]&gt;5000000</filterExpression></detailFilter></detailFilters></query><query name="Port Performance Statistics">
			<source>
				
			<sqlQuery name="SQL4" dataSource="dwh_performance" type="passThrough">
			<sqlText>SELECT

dwh_performance.switch_dimension.name as 'Switch Name',
dwh_performance.port_dimension.name as 'Port Name',
dwh_performance.port_dimension.speed as "Port Speed",
dwh_performance.port_dimension.type as "Port Type",
dwh_performance.switch_performance_for_port_hourly_fact.connectivityType as 'Connection Type',
dwh_performance.connected_device_dimension.name as 'Connected Device',
dwh_performance.connected_device_dimension.type 'Device Type',
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.rxTraffic,0) as 'Rx Traffic',
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.txTraffic,0) as 'Tx Traffic',
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.trafficUtilizationTotal,0) 'Traffic Utilization %',
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.trafficUtilizationTotalmax,0) 'Peak Traffic Utilization %',
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroRx,0) as 'bbCreditZeroRx',
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroTx,0) as 'bbCreditZeroTx',
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.errorRateFlag,0) as 'errorRateFlag',
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroRx,0)+ROUND(dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroTx,0) as 'bbCreditZeroTotal', 

ROUND(dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroMsTx,0) as 'bbCreditZeroMsTx',
dwh_performance.switch_performance_for_port_hourly_fact.class3DiscardCount as 'Class 3 Discard',
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.bbcrediterrorcount,0) as "BB Credit Error Count",
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.synclosscount,0) as "Sync Loss Count",
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.signallosscount,0) as "Signal Loss Count",
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.errorrateflag,0) as "Error Rate Flag",
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.crcerrorrateflag,0) as "CRC Error Rate Flag"




FROM dwh_performance.switch_performance_for_port_hourly_fact
JOIN dwh_performance.time_dimension
ON dwh_performance.time_dimension.tk=dwh_performance.switch_performance_for_port_hourly_fact.timetk
JOIN dwh_performance.connected_device_dimension
ON dwh_performance.connected_device_dimension.tk=dwh_performance.switch_performance_for_port_hourly_fact.connecteddevicetk
AND dwh_performance.connected_device_dimension.name is not null 
AND dwh_performance.connected_device_dimension.name &lt;&gt; 'N/A'
JOIN dwh_performance.switch_dimension
ON dwh_performance.switch_dimension.tk=dwh_performance.switch_performance_for_port_hourly_fact.switchtk
JOIN dwh_performance.port_dimension
ON dwh_performance.port_dimension.tk=dwh_performance.switch_performance_for_port_hourly_fact.porttk


GROUP BY dwh_performance.switch_dimension.name, dwh_performance.port_dimension.name , dwh_performance.port_dimension.speed

</sqlText>
		<mdProjectedItems><mdProjectedItem name="Switch Name"/><mdProjectedItem name="Port Name"/><mdProjectedItem name="Port Speed"/><mdProjectedItem name="Port Type"/><mdProjectedItem name="Connection Type"/><mdProjectedItem name="Connected Device"/><mdProjectedItem name="Device Type"/><mdProjectedItem name="Rx Traffic"/><mdProjectedItem name="Tx Traffic"/><mdProjectedItem name="Traffic Utilization %"/><mdProjectedItem name="Peak Traffic Utilization %"/><mdProjectedItem name="bbCreditZeroRx"/><mdProjectedItem name="bbCreditZeroTx"/><mdProjectedItem name="errorRateFlag"/><mdProjectedItem name="bbCreditZeroTotal"/><mdProjectedItem name="bbCreditZeroMsTx"/><mdProjectedItem name="Class 3 Discard"/><mdProjectedItem name="BB Credit Error Count"/><mdProjectedItem name="Sync Loss Count"/><mdProjectedItem name="Signal Loss Count"/><mdProjectedItem name="Error Rate Flag"/><mdProjectedItem name="CRC Error Rate Flag"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Switch Name"><expression>[SQL4].[Switch Name]</expression></dataItem><dataItem name="Port Name"><expression>[SQL4].[Port Name]</expression></dataItem><dataItem name="Port Speed"><expression>[SQL4].[Port Speed]</expression></dataItem><dataItem name="Port Type"><expression>[SQL4].[Port Type]</expression></dataItem><dataItem name="Connection Type"><expression>[SQL4].[Connection Type]</expression></dataItem><dataItem name="Connected Device"><expression>[SQL4].[Connected Device]</expression></dataItem><dataItem name="Device Type"><expression>[SQL4].[Device Type]</expression></dataItem><dataItem name="Rx Traffic" aggregate="average"><expression>[SQL4].[Rx Traffic]</expression></dataItem><dataItem name="Tx Traffic" aggregate="average"><expression>[SQL4].[Tx Traffic]</expression></dataItem><dataItem name="Traffic Utilization %" aggregate="average"><expression>[SQL4].[Traffic Utilization %]</expression></dataItem><dataItem name="Peak Traffic Utilization %" aggregate="maximum"><expression>[SQL4].[Peak Traffic Utilization %]</expression></dataItem><dataItem name="bbCreditZeroRx" aggregate="total"><expression>[SQL4].[bbCreditZeroRx]</expression></dataItem><dataItem name="bbCreditZeroTx" aggregate="total"><expression>[SQL4].[bbCreditZeroTx]</expression></dataItem><dataItem name="errorRateFlag" aggregate="total"><expression>[SQL4].[errorRateFlag]</expression></dataItem><dataItem name="bbCreditZeroTotal" aggregate="total"><expression>[SQL4].[bbCreditZeroTotal]</expression></dataItem><dataItem name="bbCreditZeroTotalMillions" aggregate="total"><expression>[bbCreditZeroTotal]/1000/1000</expression></dataItem><dataItem name="bbCreditZeroMsTx"><expression>[SQL4].[bbCreditZeroMsTx]</expression></dataItem><dataItem name="Class 3 Discard"><expression>[SQL4].[Class 3 Discard]</expression></dataItem><dataItem name="BB Credit Error Count"><expression>[SQL4].[BB Credit Error Count]</expression></dataItem><dataItem name="Sync Loss Count"><expression>[SQL4].[Sync Loss Count]</expression></dataItem><dataItem name="Signal Loss Count"><expression>[SQL4].[Signal Loss Count]</expression></dataItem><dataItem name="Error Rate Flag"><expression>[SQL4].[Error Rate Flag]</expression></dataItem><dataItem name="CRC Error Rate Flag"><expression>[SQL4].[CRC Error Rate Flag]</expression></dataItem></selection>
		<detailFilters><detailFilter use="optional"><filterExpression>[Switch Name]=?sSwitch?</filterExpression></detailFilter></detailFilters></query><query name="bbCredit Status">
			<source>
				
			<sqlQuery name="SQL2" dataSource="dwh_performance" type="passThrough">
			<sqlText>SELECT

dwh_performance.switch_dimension.name as 'Switch Name',
dwh_performance.port_dimension.name as 'Port Name',
dwh_performance.port_dimension.speed as "Port Speed",
dwh_performance.port_dimension.type as "Port Type",
dwh_performance.switch_performance_for_port_hourly_fact.connectivityType as 'Connection Type',
dwh_performance.connected_device_dimension.name as 'Connected Device',
dwh_performance.connected_device_dimension.type 'Device Type',
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.rxTraffic,0) as 'Rx Traffic',
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.txTraffic,0) as 'Tx Traffic',
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.trafficUtilizationTotal,0) 'Traffic Utilization %',
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.trafficUtilizationTotalmax,0) 'Peak Traffic Utilization %',
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroRx,0) as 'bbCreditZeroRx',
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroTx,0) as 'bbCreditZeroTx',
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.errorRateFlag,0) as 'errorRateFlag',
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroRx,0)+ROUND(dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroTx,0) as 'bbCreditZeroTotal', 

ROUND(dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroMsTx,0) as 'bbCreditZeroMsTx',
dwh_performance.switch_performance_for_port_hourly_fact.class3DiscardCount as 'Class 3 Discard',
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.bbcrediterrorcount,0) as "BB Credit Error Count",
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.synclosscount,0) as "Sync Loss Count",
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.signallosscount,0) as "Signal Loss Count",
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.errorrateflag,0) as "Error Rate Flag",
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.crcerrorrateflag,0) as "CRC Error Rate Flag"




FROM dwh_performance.switch_performance_for_port_hourly_fact
JOIN dwh_performance.time_dimension
ON dwh_performance.time_dimension.tk=dwh_performance.switch_performance_for_port_hourly_fact.timetk
JOIN dwh_performance.connected_device_dimension
ON dwh_performance.connected_device_dimension.tk=dwh_performance.switch_performance_for_port_hourly_fact.connecteddevicetk
AND dwh_performance.connected_device_dimension.name is not null 
AND dwh_performance.connected_device_dimension.name &lt;&gt; 'N/A'
JOIN dwh_performance.switch_dimension
ON dwh_performance.switch_dimension.tk=dwh_performance.switch_performance_for_port_hourly_fact.switchtk
JOIN dwh_performance.port_dimension
ON dwh_performance.port_dimension.tk=dwh_performance.switch_performance_for_port_hourly_fact.porttk

WHERE dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroRx &gt; 1000000
OR dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroTx &gt; 1000000 
OR dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroMsTx &gt; 1

GROUP BY dwh_performance.switch_dimension.name, dwh_performance.port_dimension.name

ORDER BY (dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroRx+dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroTx) DESC LIMIT 10




</sqlText>
		<mdProjectedItems><mdProjectedItem name="Switch Name"/><mdProjectedItem name="Port Name"/><mdProjectedItem name="Port Speed"/><mdProjectedItem name="Port Type"/><mdProjectedItem name="Connection Type"/><mdProjectedItem name="Connected Device"/><mdProjectedItem name="Device Type"/><mdProjectedItem name="Rx Traffic"/><mdProjectedItem name="Tx Traffic"/><mdProjectedItem name="Traffic Utilization %"/><mdProjectedItem name="Peak Traffic Utilization %"/><mdProjectedItem name="bbCreditZeroRx"/><mdProjectedItem name="bbCreditZeroTx"/><mdProjectedItem name="errorRateFlag"/><mdProjectedItem name="bbCreditZeroTotal"/><mdProjectedItem name="bbCreditZeroMsTx"/><mdProjectedItem name="Class 3 Discard"/><mdProjectedItem name="BB Credit Error Count"/><mdProjectedItem name="Sync Loss Count"/><mdProjectedItem name="Signal Loss Count"/><mdProjectedItem name="Error Rate Flag"/><mdProjectedItem name="CRC Error Rate Flag"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Switch Name"><expression>[SQL2].[Switch Name]</expression></dataItem><dataItem name="Port Name"><expression>[SQL2].[Port Name]</expression></dataItem><dataItem name="Port Speed"><expression>[SQL2].[Port Speed]</expression></dataItem><dataItem name="Port Type"><expression>[SQL2].[Port Type]</expression></dataItem><dataItem name="Connection Type"><expression>[SQL2].[Connection Type]</expression></dataItem><dataItem name="Connected Device"><expression>[SQL2].[Connected Device]</expression></dataItem><dataItem name="Device Type"><expression>[SQL2].[Device Type]</expression></dataItem><dataItem name="Rx Traffic"><expression>[SQL2].[Rx Traffic]</expression></dataItem><dataItem name="Tx Traffic"><expression>[SQL2].[Tx Traffic]</expression></dataItem><dataItem name="Traffic Utilization %"><expression>[SQL2].[Traffic Utilization %]</expression></dataItem><dataItem name="Peak Traffic Utilization %"><expression>[SQL2].[Peak Traffic Utilization %]</expression></dataItem><dataItem name="bbCreditZeroRx" aggregate="total"><expression>[SQL2].[bbCreditZeroRx]</expression></dataItem><dataItem name="bbCreditZeroTx" aggregate="total"><expression>[SQL2].[bbCreditZeroTx]</expression></dataItem><dataItem name="errorRateFlag"><expression>[SQL2].[errorRateFlag]</expression></dataItem><dataItem name="bbCreditZeroTotal"><expression>[SQL2].[bbCreditZeroTotal]</expression></dataItem><dataItem name="bbCreditZeroMsTx"><expression>[SQL2].[bbCreditZeroMsTx]</expression></dataItem><dataItem name="Class 3 Discard"><expression>[SQL2].[Class 3 Discard]</expression></dataItem><dataItem name="BB Credit Error Count"><expression>[SQL2].[BB Credit Error Count]</expression></dataItem><dataItem name="Sync Loss Count"><expression>[SQL2].[Sync Loss Count]</expression></dataItem><dataItem name="Signal Loss Count"><expression>[SQL2].[Signal Loss Count]</expression></dataItem><dataItem name="Error Rate Flag"><expression>[SQL2].[Error Rate Flag]</expression></dataItem><dataItem name="CRC Error Rate Flag"><expression>[SQL2].[CRC Error Rate Flag]</expression></dataItem></selection>
		<detailFilters><detailFilter use="optional"><filterExpression>[Switch Name]=?sSwitch?</filterExpression></detailFilter></detailFilters></query><query name="Port Performance Trends">
			<source>
				
			<sqlQuery name="SQL3" dataSource="dwh_performance" type="passThrough">
			<sqlText>SELECT

dwh_performance.switch_dimension.name as 'Switch Name',
dwh_performance.port_dimension.name as 'Port Name',
dwh_performance.port_dimension.speed as "Port Speed",
dwh_performance.port_dimension.type as "Port Type",
dwh_performance.switch_performance_for_port_hourly_fact.connectivityType as 'Connection Type',
dwh_performance.connected_device_dimension.name as 'Connected Device',
dwh_performance.connected_device_dimension.type 'Device Type',
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.rxTraffic,0) as 'Rx Traffic',
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.txTraffic,0) as 'Tx Traffic',
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.TotalTraffic,0) as 'Total Traffic',
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.trafficUtilizationTotal,0) 'Traffic Utilization %',
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.trafficUtilizationTotalmax,0) 'Peak Traffic Utilization %',
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroRx,0) as 'bbCreditZeroRx',
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroTx,0) as 'bbCreditZeroTx',
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.errorRateFlag,0) as 'errorRateFlag',
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroRx,0)+ROUND(dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroTx,0) as 'bbCreditZeroTotal', 

ROUND(dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroMsTx,0) as 'bbCreditZeroMsTx',
dwh_performance.switch_performance_for_port_hourly_fact.class3DiscardCount as 'Class 3 Discard',
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.bbcrediterrorcount,0) as "BB Credit Error Count",
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.synclosscount,0) as "Sync Loss Count",
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.signallosscount,0) as "Signal Loss Count",
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.errorrateflag,0) as "Error Rate Flag",
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.crcerrorrateflag,0) as "CRC Error Rate Flag",

dwh_performance.time_dimension.hourdatetime as 'Date/Time'




FROM dwh_performance.switch_performance_for_port_hourly_fact
JOIN dwh_performance.time_dimension
ON dwh_performance.time_dimension.tk=dwh_performance.switch_performance_for_port_hourly_fact.timetk
JOIN dwh_performance.connected_device_dimension
ON dwh_performance.connected_device_dimension.tk=dwh_performance.switch_performance_for_port_hourly_fact.connecteddevicetk
AND dwh_performance.connected_device_dimension.name is not null 
AND dwh_performance.connected_device_dimension.name &lt;&gt; 'N/A'
JOIN dwh_performance.switch_dimension
ON dwh_performance.switch_dimension.tk=dwh_performance.switch_performance_for_port_hourly_fact.switchtk
JOIN dwh_performance.port_dimension
ON dwh_performance.port_dimension.tk=dwh_performance.switch_performance_for_port_hourly_fact.porttk


GROUP BY dwh_performance.switch_dimension.name , dwh_performance.port_dimension.speed, dwh_performance.time_dimension.hourdatetime

</sqlText>
		<mdProjectedItems><mdProjectedItem name="Switch Name"/><mdProjectedItem name="Port Name"/><mdProjectedItem name="Port Speed"/><mdProjectedItem name="Port Type"/><mdProjectedItem name="Connection Type"/><mdProjectedItem name="Connected Device"/><mdProjectedItem name="Device Type"/><mdProjectedItem name="Rx Traffic"/><mdProjectedItem name="Tx Traffic"/><mdProjectedItem name="Total Traffic"/><mdProjectedItem name="Traffic Utilization %"/><mdProjectedItem name="Peak Traffic Utilization %"/><mdProjectedItem name="bbCreditZeroRx"/><mdProjectedItem name="bbCreditZeroTx"/><mdProjectedItem name="errorRateFlag"/><mdProjectedItem name="bbCreditZeroTotal"/><mdProjectedItem name="bbCreditZeroMsTx"/><mdProjectedItem name="Class 3 Discard"/><mdProjectedItem name="BB Credit Error Count"/><mdProjectedItem name="Sync Loss Count"/><mdProjectedItem name="Signal Loss Count"/><mdProjectedItem name="Error Rate Flag"/><mdProjectedItem name="CRC Error Rate Flag"/><mdProjectedItem name="Date/Time"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Switch Name"><expression>[SQL3].[Switch Name]</expression></dataItem><dataItem name="Port Name"><expression>[SQL3].[Port Name]</expression></dataItem><dataItem name="Port Speed"><expression>[SQL3].[Port Speed]</expression></dataItem><dataItem name="Port Type"><expression>[SQL3].[Port Type]</expression></dataItem><dataItem name="Connection Type"><expression>[SQL3].[Connection Type]</expression></dataItem><dataItem name="Connected Device"><expression>[SQL3].[Connected Device]</expression></dataItem><dataItem name="Device Type"><expression>[SQL3].[Device Type]</expression></dataItem><dataItem name="Rx Traffic" aggregate="average"><expression>[SQL3].[Rx Traffic]</expression></dataItem><dataItem name="Tx Traffic" aggregate="average"><expression>[SQL3].[Tx Traffic]</expression></dataItem><dataItem name="Total Traffic" aggregate="average"><expression>[SQL3].[Total Traffic]</expression></dataItem><dataItem name="Traffic Utilization %"><expression>[SQL3].[Traffic Utilization %]</expression></dataItem><dataItem name="Peak Traffic Utilization %"><expression>[SQL3].[Peak Traffic Utilization %]</expression></dataItem><dataItem name="bbCreditZeroRx"><expression>[SQL3].[bbCreditZeroRx]</expression></dataItem><dataItem name="bbCreditZeroTx"><expression>[SQL3].[bbCreditZeroTx]</expression></dataItem><dataItem name="errorRateFlag"><expression>[SQL3].[errorRateFlag]</expression></dataItem><dataItem name="bbCreditZeroTotal"><expression>[SQL3].[bbCreditZeroTotal]</expression></dataItem><dataItem name="bbCreditZeroMsTx"><expression>[SQL3].[bbCreditZeroMsTx]</expression></dataItem><dataItem name="Class 3 Discard"><expression>[SQL3].[Class 3 Discard]</expression></dataItem><dataItem name="BB Credit Error Count"><expression>[SQL3].[BB Credit Error Count]</expression></dataItem><dataItem name="Sync Loss Count"><expression>[SQL3].[Sync Loss Count]</expression></dataItem><dataItem name="Signal Loss Count"><expression>[SQL3].[Signal Loss Count]</expression></dataItem><dataItem name="Error Rate Flag"><expression>[SQL3].[Error Rate Flag]</expression></dataItem><dataItem name="CRC Error Rate Flag"><expression>[SQL3].[CRC Error Rate Flag]</expression></dataItem><dataItem name="Date/Time"><expression>[SQL3].[Date/Time]</expression></dataItem></selection>
		<detailFilters><detailFilter use="optional"><filterExpression>[Switch Name]=?sSwitch?</filterExpression></detailFilter></detailFilters></query><query name="Switch Ports">
			<source>
				
			<sqlQuery dataSource="dwh_inventory" name="SQL1">
			<sqlText>SELECT
	dwh_inventory.switch.name as 'Switch',
	'Total Ports' AS 'device',
	COUNT(DISTINCT dwh_inventory.switch_port.id) AS 'metric'
FROM
	dwh_inventory.switch_port
JOIN
	dwh_inventory.switch
ON
	dwh_inventory.switch_port.switchId = dwh_inventory.switch.id
AND
	dwh_inventory.switch.npv = 0
AND
	dwh_inventory.switch_port.id NOT IN (SELECT dwh_inventory.switch_port.id FROM dwh_inventory.switch_port WHERE dwh_inventory.switch_port.gbicType LIKE '%ICL%')
AND
	dwh_inventory.switch_port.active = 1
AND
	dwh_inventory.switch_port.status &lt;&gt; 'NOT_LICENSED'
AND
	dwh_inventory.switch_port.name NOT LIKE '%vfc%'

GROUP BY dwh_inventory.switch.name

UNION
SELECT 	
	dwh_inventory.switch.name as 'Switch',
	'Free Ports' AS 'device',
	COUNT(DISTINCT dwh_inventory.switch_port.id) AS 'metric'
FROM
	dwh_inventory.switch_port
JOIN
	dwh_inventory.switch
ON
	dwh_inventory.switch_port.switchId = dwh_inventory.switch.id
AND
	dwh_inventory.switch.npv = 0
AND
	dwh_inventory.switch_port.id NOT IN (SELECT dwh_inventory.switch_port.id FROM dwh_inventory.switch_port WHERE dwh_inventory.switch_port.gbicType LIKE '%ICL%')
AND
	dwh_inventory.switch_port.active = 1
AND
	dwh_inventory.switch_port.status &lt;&gt; 'NOT_LICENSED'
AND
	dwh_inventory.switch_port.name NOT LIKE '%vfc%'
AND
	dwh_inventory.switch_port.id NOT IN (SELECT dwh_inventory.port_connectivity.portId FROM dwh_inventory.port_connectivity)
GROUP BY dwh_inventory.switch.name

UNION
SELECT 	
dwh_inventory.switch.name as 'Switch',
	'Used Ports' AS 'device',
	COUNT(DISTINCT dwh_inventory.switch_port.id) AS 'metric'
FROM
	dwh_inventory.switch_port
JOIN
	dwh_inventory.switch
ON
	dwh_inventory.switch_port.switchId = dwh_inventory.switch.id
AND
	dwh_inventory.switch.npv = 0
AND
	dwh_inventory.switch_port.id NOT IN (SELECT dwh_inventory.switch_port.id FROM dwh_inventory.switch_port WHERE dwh_inventory.switch_port.gbicType LIKE '%ICL%')
AND
	dwh_inventory.switch_port.active = 1
AND
	dwh_inventory.switch_port.status &lt;&gt; 'NOT_LICENSED'
AND
	dwh_inventory.switch_port.name NOT LIKE '%vfc%'
AND
	dwh_inventory.switch_port.id IN (SELECT dwh_inventory.port_connectivity.portId FROM dwh_inventory.port_connectivity)

GROUP BY dwh_inventory.switch.name</sqlText>
		<mdProjectedItems><mdProjectedItem name="Switch"/><mdProjectedItem name="device"/><mdProjectedItem name="metric"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="device"><expression>[SQL1].[device]</expression></dataItem><dataItem name="metric"><expression>[SQL1].[metric]</expression></dataItem><dataItem aggregate="total" name="Total Ports"><expression>IF([device]='Total Ports') THEN ([metric]) ELSE (0)</expression></dataItem><dataItem aggregate="total" name="Used Ports"><expression>IF([device]='Used Ports') THEN ([metric]) ELSE (0)</expression></dataItem><dataItem aggregate="total" name="Free Ports"><expression>IF([device]='Free Ports') THEN ([metric]) ELSE (0)</expression></dataItem><dataItem name="% Free Ports"><expression>[Free Ports]/[Total Ports]</expression></dataItem><dataItem name="Switch"><expression>[SQL1].[Switch]</expression></dataItem></selection>
		<detailFilters><detailFilter use="optional"><filterExpression>[Switch]=?sSwitch?
</filterExpression></detailFilter></detailFilters></query><query name="sSwitch">
			<source>
				
			<sqlQuery dataSource="dwh_performance" name="SQL2">
			<sqlText>SELECT
	dwh_inventory.switch.name as 'Switch',
	'Total Ports' AS 'device',
	COUNT(DISTINCT dwh_inventory.switch_port.id) AS 'metric'
FROM
	dwh_inventory.switch_port
JOIN
	dwh_inventory.switch
ON
	dwh_inventory.switch_port.switchId = dwh_inventory.switch.id
AND
	dwh_inventory.switch.npv = 0
AND
	dwh_inventory.switch_port.id NOT IN (SELECT dwh_inventory.switch_port.id FROM dwh_inventory.switch_port WHERE dwh_inventory.switch_port.gbicType LIKE '%ICL%')
AND
	dwh_inventory.switch_port.active = 1
AND
	dwh_inventory.switch_port.status &lt;&gt; 'NOT_LICENSED'
AND
	dwh_inventory.switch_port.name NOT LIKE '%vfc%'

GROUP BY dwh_inventory.switch.name

UNION
SELECT 	
	dwh_inventory.switch.name as 'Switch',
	'Free Ports' AS 'device',
	COUNT(DISTINCT dwh_inventory.switch_port.id) AS 'metric'
FROM
	dwh_inventory.switch_port
JOIN
	dwh_inventory.switch
ON
	dwh_inventory.switch_port.switchId = dwh_inventory.switch.id
AND
	dwh_inventory.switch.npv = 0
AND
	dwh_inventory.switch_port.id NOT IN (SELECT dwh_inventory.switch_port.id FROM dwh_inventory.switch_port WHERE dwh_inventory.switch_port.gbicType LIKE '%ICL%')
AND
	dwh_inventory.switch_port.active = 1
AND
	dwh_inventory.switch_port.status &lt;&gt; 'NOT_LICENSED'
AND
	dwh_inventory.switch_port.name NOT LIKE '%vfc%'
AND
	dwh_inventory.switch_port.id NOT IN (SELECT dwh_inventory.port_connectivity.portId FROM dwh_inventory.port_connectivity)
GROUP BY dwh_inventory.switch.name

UNION
SELECT 	
dwh_inventory.switch.name as 'Switch',
	'Used Ports' AS 'device',
	COUNT(DISTINCT dwh_inventory.switch_port.id) AS 'metric'
FROM
	dwh_inventory.switch_port
JOIN
	dwh_inventory.switch
ON
	dwh_inventory.switch_port.switchId = dwh_inventory.switch.id
AND
	dwh_inventory.switch.npv = 0
AND
	dwh_inventory.switch_port.id NOT IN (SELECT dwh_inventory.switch_port.id FROM dwh_inventory.switch_port WHERE dwh_inventory.switch_port.gbicType LIKE '%ICL%')
AND
	dwh_inventory.switch_port.active = 1
AND
	dwh_inventory.switch_port.status &lt;&gt; 'NOT_LICENSED'
AND
	dwh_inventory.switch_port.name NOT LIKE '%vfc%'
AND
	dwh_inventory.switch_port.id IN (SELECT dwh_inventory.port_connectivity.portId FROM dwh_inventory.port_connectivity)

GROUP BY dwh_inventory.switch.name</sqlText>
		<mdProjectedItems><mdProjectedItem name="Switch"/><mdProjectedItem name="device"/><mdProjectedItem name="metric"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Switch Name"><expression>[SQL2].[Switch]</expression></dataItem></selection>
		<detailFilters><detailFilter><filterExpression>[Switch Name]&lt;&gt;'N/A'</filterExpression></detailFilter></detailFilters></query></queries>
				<layouts>
					<layout>
						<reportPages>
							<page name="Page1"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles></style>
								<pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles></style>
									<contents>
										
									<HTMLItem>
			<dataSource>
				<staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>
			</dataSource>
		</HTMLItem><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:1500px"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;background-color:#6198C5;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Switch Port Performance</staticValue></dataSource></textItem></contents><style><CSS value="height:36px;padding-left:10px;font-family:Arial;font-size:24px;color:#333333;background-color:#FBFBFB;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total Ports</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><repeater name="Repeater1" refQuery="Switch Ports">
			<contents><textItem><dataSource><dataItemValue refDataItem="Total Ports"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/></style></textItem></contents>
		</repeater></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total Used Ports</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><repeater name="Repeater2" refQuery="Switch Ports">
			<contents><textItem><dataSource><dataItemValue refDataItem="Used Ports"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/></style></textItem></contents>
		</repeater></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>% Free Ports</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><repeater name="Repeater3" refQuery="Switch Ports">
			<contents><textItem><dataSource><dataItemValue refDataItem="% Free Ports"/></dataSource><style><dataFormat><percentFormat/></dataFormat><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/></style></textItem></contents>
		</repeater></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Switch Traffic Utilization</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><repeater name="Repeater4" refQuery="Port Performance Statistics">
			<contents><textItem><dataSource><dataItemValue refDataItem="Traffic Utilization %"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###'%'"/></dataFormat></style></textItem></contents>
		</repeater></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Switch Peak Utilization</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><repeater name="Repeater5" refQuery="Port Performance Statistics">
			<contents><textItem><dataSource><dataItemValue refDataItem="Peak Traffic Utilization %"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###'%'"/></dataFormat></style></textItem></contents>
		</repeater></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>bbCreditZeroTotal</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><repeater name="Repeater6" refQuery="Port Performance Statistics">
			<contents><textItem><dataSource><dataItemValue refDataItem="bbCreditZeroTotalMillions"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,### M"/></dataFormat></style></textItem></contents>
		</repeater></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="background-color:#F7F7F7;padding-bottom:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Port Traffic</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(by Port Speed)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents><v2_combinationChart maxHotspots="10000" name="Combination Chart1" refQuery="Port Performance Statistics" depth="9">
																																<v2_combinationTypeTooltips/>
																																<v2_legend>
																																	<style>
																																								<defaultStyles>
																																									<defaultStyle refStyle="lg"/>
																																								</defaultStyles>
																																								<CSS value="color:#454545"/></style><v2_legendPosition>
																																		<v2_legendPreset legendPositionPreset="bottom"/>
																																	</v2_legendPosition></v2_legend>
																																<v2_commonAxis>
																																	<v2_ordinalAxis>
																																		<v2_axisLabels>
																																			<style>
																																				<defaultStyles>
																																					<defaultStyle refStyle="al"/>
																																				</defaultStyles>
																																			</style>
																																		</v2_axisLabels>
																																	</v2_ordinalAxis>
																																	<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Port Speed"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																																<v2_topLeftAxis>
																																	<v2_combinationChartTypes>
																																		<v2_bar seriesType="stacked" borderColor="white" setOrdinalWidthScale="80" bevel="none" barShape="box">
																																			<v2_solidPalette>
																																				<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Rx Traffic"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="Tx Traffic"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
																																	</v2_combinationChartTypes>
																																	<v2_axis>
																																		<v2_axisRange scale="log">
																																			<v2_automaticRange sameRangeAllInstances="true" includeZeroForAutoScale="true"/>
																																		</v2_axisRange>
																																		<v2_axisLabels>
																																			<style>
																																				<defaultStyles>
																																					<defaultStyle refStyle="al"/>
																																				</defaultStyles>
																																				<CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,###' MB'"/></dataFormat></style>
																																		</v2_axisLabels><v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/></v2_axis>
																																</v2_topLeftAxis>
																																<style>
																																	<CSS value="width:480px;height:200px;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																																
																																</v2_combinationChart>
																														</contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Port Traffic</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(by Type)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														
					<v2_combinationChart maxHotspots="10000" name="Combination Chart4" refQuery="Port Performance Statistics" depth="9">
							<v2_combinationTypeTooltips/>
							<v2_legend>
								<style>
																																								<defaultStyles>
																																									<defaultStyle refStyle="lg"/>
																																								</defaultStyles>
																																								<CSS value="color:#454545"/></style><v2_legendPosition>
																																		<v2_legendPreset legendPositionPreset="bottom"/>
																																	</v2_legendPosition></v2_legend>
							<v2_commonAxis>
								<v2_ordinalAxis>
									<v2_axisLabels>
										<style>
											<defaultStyles>
												<defaultStyle refStyle="al"/>
											</defaultStyles>
										</style>
									</v2_axisLabels>
								</v2_ordinalAxis>
								<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Port Type"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
							<v2_topLeftAxis>
								<v2_combinationChartTypes>
									<v2_bar seriesType="stacked" borderColor="white" setOrdinalWidthScale="80" bevel="none" barShape="box">
										<v2_solidPalette>
																																				<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Rx Traffic"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="Tx Traffic"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
								</v2_combinationChartTypes>
								<v2_axis>
									<v2_axisRange scale="log">
										
									<v2_automaticRange sameRangeAllInstances="true" includeZeroForAutoScale="true"/></v2_axisRange>
									<v2_axisLabels>
																																			<style>
																																				<defaultStyles>
																																					<defaultStyle refStyle="al"/>
																																				</defaultStyles>
																																				<CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,### MB"/></dataFormat></style>
																																		</v2_axisLabels><v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/></v2_axis>
							</v2_topLeftAxis>
							<style>
								<CSS value="width:480px;height:200px;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
							
							</v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Port Utilization %</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(by Port Speed)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents><v2_combinationChart maxHotspots="10000" name="Combination Chart2" refQuery="Port Performance Statistics" depth="9">
							<v2_combinationTypeTooltips/>
							<v2_legend>
								<style>
																																								<defaultStyles>
																																									<defaultStyle refStyle="lg"/>
																																								</defaultStyles>
																																								<CSS value="color:#454545"/></style><v2_legendPosition>
																																		<v2_legendPreset legendPositionPreset="bottom"/>
																																	</v2_legendPosition></v2_legend>
							<v2_commonAxis>
								<v2_ordinalAxis>
									<v2_axisLabels>
										<style>
											<defaultStyles>
												<defaultStyle refStyle="al"/>
											</defaultStyles>
										</style>
									</v2_axisLabels>
								</v2_ordinalAxis>
								<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Port Speed"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
							<v2_topLeftAxis>
								<v2_combinationChartTypes>
									<v2_bar seriesType="stacked" borderColor="white" setOrdinalWidthScale="80" bevel="none" barShape="box">
										<v2_solidPalette>
																																				<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Traffic Utilization %"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="Peak Traffic Utilization %"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
								</v2_combinationChartTypes>
								<v2_axis>
									<v2_axisRange scale="linear">
										
									<v2_specifiedRange includeZeroForAutoScale="true" max="100" scaleInterval="20" min="0"/></v2_axisRange>
									<v2_axisLabels>
																																			<style>
																																				<defaultStyles>
																																					<defaultStyle refStyle="al"/>
																																				</defaultStyles>
																																				<CSS value="color:#454545"/><dataFormat><numberFormat pattern="###.##'%'"/></dataFormat></style>
																																		</v2_axisLabels><v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/></v2_axis>
							</v2_topLeftAxis>
							<style>
								<CSS value="width:480px;height:200px;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
							
							</v2_combinationChart>
																														</contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell colSpan="2"><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;width:100%;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Port Traffic Trends</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(by All Ports)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" refQuery="Port Performance Trends" name="Combination Chart7">
																																<v2_combinationTypeTooltips/>
																																<v2_legend>
																																	<v2_legendPosition>
																						<v2_legendPreset legendPositionPreset="bottom"/>
																					</v2_legendPosition><style>
																						<defaultStyles>
																							<defaultStyle refStyle="lg"/>
																						</defaultStyles>
																					<CSS value="font-family:Arial;color:#454545"/></style></v2_legend>
																																<v2_commonAxis>
																																	<v2_ordinalAxis>
																																		<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/></style>
																						</v2_axisLabels><v2_labelControl/></v2_ordinalAxis>
																																	<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Date/Time"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Date/Time"/></dataSource></chartTextItem></chartContents><style><dataFormat><dateTimeFormat pattern="MM/dd"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																																<v2_topLeftAxis>
																																	<v2_combinationChartTypes>
																																		<v2_line>
																																			<v2_linePalette markerBorderColor="white" markerBorders="show" markerSize="8px"><v2_linePaletteEntries><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#8599D3"><v2_solidColor color="#9ABCC3" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#8599D3"><v2_color color="#9ABCC3"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#E3AE6C"><v2_solidColor color="#A8E3D7" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#E3AE6C"><v2_color color="#A8E3D7"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry><v2_lineFill defaultColor="#198545"><v2_color color="#88B2D3"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry><v2_lineFill defaultColor="#198545"><v2_color color="#FFB2C1"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry></v2_linePaletteEntries></v2_linePalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Rx Traffic"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="Tx Traffic"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_line>
																																	</v2_combinationChartTypes>
																																	<v2_axis>
																																		<v2_axisRange>
																							
																						<v2_specifiedRange max="1"/></v2_axisRange><v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/><dataFormat><numberFormat pattern="###,###' MB'"/></dataFormat></style>
																						</v2_axisLabels><v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/></v2_axis>
																																</v2_topLeftAxis>
																																<style>
																																	<CSS value="width:960px;height:200px"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																																
																																</v2_combinationChart>
																														</contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-top:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>bbCreditZero Status</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Potential Slow Drain Catalyst)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents><v2_combinationChart maxHotspots="10000" name="Combination Chart3" refQuery="bbCredit Status" depth="9">
							<v2_combinationTypeTooltips/>
							<v2_legend>
								<style>
																																								<defaultStyles>
																																									<defaultStyle refStyle="lg"/>
																																								</defaultStyles>
																																								<CSS value="color:#454545"/></style><v2_legendPosition>
																																		<v2_legendPreset legendPositionPreset="bottom"/>
																																	</v2_legendPosition></v2_legend>
							<v2_commonAxis>
								<v2_ordinalAxis>
									<v2_axisLabels>
										<style>
											<defaultStyles>
												<defaultStyle refStyle="al"/>
											</defaultStyles>
										</style>
									</v2_axisLabels>
								</v2_ordinalAxis>
								<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Switch Name"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
							<v2_topLeftAxis>
								<v2_combinationChartTypes>
									<v2_bar seriesType="stacked" borderColor="white" setOrdinalWidthScale="80" bevel="none" barShape="box">
										<v2_solidPalette>
																																				<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="bbCreditZeroRx"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="bbCreditZeroTx"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
								</v2_combinationChartTypes>
								<v2_axis>
									<v2_axisRange scale="linear">
										
									<v2_automaticRange sameRangeAllInstances="true" includeZeroForAutoScale="true"/></v2_axisRange>
									<v2_axisLabels>
																																			<style>
																																				<defaultStyles>
																																					<defaultStyle refStyle="al"/>
																																				</defaultStyles>
																																				<CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,###,###,### bbCredits"/></dataFormat></style>
																																		</v2_axisLabels><v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/></v2_axis>
							</v2_topLeftAxis>
							<style>
								<CSS value="width:480px;height:200px;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
							
							</v2_combinationChart>
																														</contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px;padding-top:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents/></tableCell><tableCell><contents/></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell><tableCell><contents/></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:10px;background-color:#F7F7F7;padding-right:10px;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Switch Port Detail</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<block>
			<contents><list horizontalPagination="true" name="List1" refQuery="Port Performance Statistics" rowsPerPage="5000">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Switch Name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Switch Name"/></dataSource></textItem></contents><listColumnRowSpan refDataItem="Switch Name"/></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Port Name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Port Name"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Port Speed"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Port Speed"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Port Type"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Port Type"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Connection Type"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Connection Type"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Connected Device"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Connected Device"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Device Type"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Device Type"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Rx Traffic"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Rx Traffic"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Tx Traffic"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Tx Traffic"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Traffic Utilization %"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Traffic Utilization %"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Peak Traffic Utilization %"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Peak Traffic Utilization %"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="bbCreditZeroRx"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="bbCreditZeroRx"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="bbCreditZeroTx"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="bbCreditZeroTx"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="errorRateFlag"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="errorRateFlag"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="bbCreditZeroTotal"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="bbCreditZeroTotal"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="bbCreditZeroMsTx"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="bbCreditZeroMsTx"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Class 3 Discard"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Class 3 Discard"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="BB Credit Error Count"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="BB Credit Error Count"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Sync Loss Count"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Sync Loss Count"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Signal Loss Count"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Signal Loss Count"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Error Rate Flag"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Error Rate Flag"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="CRC Error Rate Flag"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="CRC Error Rate Flag"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns><listGroups><listGroup refDataItem="Switch Name"/></listGroups></list></contents>
		<style><CSS value="width:1500px;height:300px;overflow:auto"/></style></block></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding:5px 10px 10px 10px;height:10px;background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents><textItem><dataSource><staticValue>Select Switch:</staticValue></dataSource><style><CSS value="font-weight:bold;font-size:12pt;color:gray"/></style></textItem></contents></tableCell><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents><selectValue multiSelect="false" parameter="sSwitch" refQuery="sSwitch" required="false" selectValueUI="radioGroup"><style><CSS value="width:200px;height:400px"/></style><useItem refDataItem="Switch Name"/><sortList><sortItem refDataItem="Switch Name"/></sortList></selectValue></contents></tableCell><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents><promptButton type="next">
			<contents><textItem><dataSource><staticValue>Apply</staticValue></dataSource></textItem></contents>
			<style>
				<defaultStyles>
					<defaultStyle refStyle="bp"/>
				</defaultStyles>
			<CSS value="background-color:silver"/></style>
		</promptButton></contents><style><CSS value="padding-top:5px;padding-left:15px"/></style></tableCell><tableCell><contents/></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top;padding-left:15px;padding-top:50px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents>
								</pageBody>
								
								<pageFooter>
									<contents>
										
									<table>
                                            <tableRows>
                                                <tableRow>
                                                    <tableCells>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <image>
            <dataSource>
                <staticValue>../sanscreen/images/netapp_logo.png</staticValue>
            </dataSource>
        <style><CSS value="width:90px;height:36px"/></style></image></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:left;width:30%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                <textItem><dataSource><staticValue>Page </staticValue></dataSource></textItem><pageNumber/>
                                                            </contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:center;color:#9EA2A2;font-family:Helvetica;font-size:12px;width:40%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <textItem><dataSource><staticValue>OnCommand Insight 7.3.  2014-18 NetApp.</staticValue></dataSource><style><CSS value="font-weight:normal"/></style></textItem></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:right;width:30%;color:#9EA2A2;font-family:Arial;font-size:12px"/>
                                                            </style>
                                                        </tableCell>
                                                    </tableCells>
                                                </tableRow>
                                            </tableRows>
                                            <style>
                                                <defaultStyles>
                                                    <defaultStyle refStyle="tb"/>
                                                </defaultStyles>
                                                <CSS value="border-collapse:collapse;width:100%;height:32px"/>
                                            </style>
                                        </table></contents>
									<style>
										<defaultStyles>
											<defaultStyle refStyle="pf"/>
										</defaultStyles>
										<CSS value="padding-top:10px"/>
									</style>
								</pageFooter>
							</page>
						</reportPages>
					</layout>
				</layouts>
			<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" output="no" value="true"/><XMLAttribute name="listSeparator" output="no" value=","/><XMLAttribute name="RS_modelModificationTime" output="no" value="2017-11-15T20:33:46.858Z"/></XMLAttributes><reportName>3.14 Switch Port Performance</reportName></report>